<?php

$query = "select CJ.num_Jugador as NUMERO,CJ.nom_Jugador as JUGADOR,TC.des_infraccion as INFRACCION,TC.des_Castigo as CASTIGO,TC.fecha_Inicio as INICIO,TC.fecha_Fin as FIN from Tab_Castigos as TC inner join Cat_Jugadores as CJ on TC.num_Jugador=CJ.num_Jugador";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {
    echo "<tr><td width=\"5%\"><center><font face=\"verdana\">" .
    $row["NUMERO"] . "</font></center></td>";
    echo "<td><font face=\"verdana\">" .
    $row["JUGADOR"] . "</font></td>";
    echo "<td><font face=\"verdana\">" .
    $row["INFRACCION"] . "</font></td>";
    echo "<td width=\"5%\"><center><font face=\"verdana\">" .
    $row["CASTIGO"] . "</font></center></td>";
    echo "<td width=\"5%\"><center><font face=\"verdana\">" .
    $row["INICIO"] . "</font></center></td>";
    echo "<td width=\"10%\"><font face=\"verdana\">" .
    $row["FIN"] . "</font></td></tr>";
}
mysql_free_result($result);
mysql_close($link);
?>